package com.wy.authority.mapper;

import com.wy.authority.entity.Procurement;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Author 忘忧
 * @Date Created in 2021/2/1 14:42
 * @Description:
 */
@Mapper
@Repository
public interface ProcurementMapper {

    //查询所有采购信息
    List<Procurement> findall();

    List<Procurement> findbyid(int proc_id);

    //分页查询
    List<Procurement> find_bynum(int pagenum,int pagesize);

    //统计总数
    Long gettotal();

    //添加采购信息
    int insert(Procurement procurement);

    //修改采购信息
    int update(Procurement procurement);

    //更新状态
    int update2(Procurement procurement);

    //删除采购信息
    int delete(int pro_id);

    //按照订单编号油品采购人模糊查询
    List<Procurement> selectby_ord(String search,String type,String people);
}
